Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 314 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 39.2 KiB |
| Average record size in memory | 128.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 1 |
| DateTime | 1 |
YEAR is highly correlated with formatted_date | High correlation |
PM_RETIRO is highly correlated with PM_CIUDADLINEAL | High correlation |
PM_CIUDADLINEAL is highly correlated with PM_RETIRO | High correlation |
DEW_POINT is highly correlated with TEMPERATURE | High correlation |
TEMPERATURE is highly correlated with DEW_POINT | High correlation |
formatted_date is highly correlated with YEAR | High correlation |
TEMPERATURE has unique values | Unique |
WIND_SPEED has unique values | Unique |
formatted_date has unique values | Unique |
PM_RETIRO has 158 (50.3%) zeros | Zeros |
PM_VALLECAS has 165 (52.5%) zeros | Zeros |
PM_CIUDADLINEAL has 158 (50.3%) zeros | Zeros |
COMMULATIVE_PRECIPITATION has 130 (41.4%) zeros | Zeros |
Reproduction
| Analysis started | 2021-05-04 16:43:03.863674 |
|---|---|
| Analysis finished | 2021-05-04 16:43:39.519536 |
| Duration | 35.66 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
| Distinct | 6 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2012.5 |
|---|---|
| Minimum | 2010 |
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 2010 |
|---|---|
| 5-th percentile | 2010 |
| Q1 | 2011 |
| median | 2012.5 |
| Q3 | 2014 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.716765664 |
|---|---|
| Coefficient of variation (CV) | 0.0008530512616 |
| Kurtosis | -1.276741608 |
| Mean | 2012.5 |
| Median Absolute Deviation (MAD) | 1.5 |
| Skewness | 0 |
| Sum | 631925 |
| Variance | 2.947284345 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) |
| 2015 | 53 | |
| 2010 | 53 | |
| 2014 | 52 | |
| 2013 | 52 | |
| 2012 | 52 | |
| 2011 | 52 |
| Value | Count | Frequency (%) |
| 2010 | 53 | |
| 2011 | 52 | |
| 2012 | 52 | |
| 2013 | 52 | |
| 2014 | 52 |
| Value | Count | Frequency (%) |
| 2015 | 53 | |
| 2014 | 52 | |
| 2013 | 52 | |
| 2012 | 52 | |
| 2011 | 52 |
Week
Real number (ℝ≥0)
| Distinct | 53 |
|---|---|
| Distinct (%) | 16.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.66878981 |
|---|---|
| Minimum | 1 |
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 14 |
| median | 27 |
| Q3 | 40 |
| 95-th percentile | 50 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 15.13238219 |
|---|---|
| Coefficient of variation (CV) | 0.5674191556 |
| Kurtosis | -1.19964865 |
| Mean | 26.66878981 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.0008578062142 |
| Sum | 8374 |
| Variance | 228.9889909 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 27 | 6 | 1.9% |
| 26 | 6 | 1.9% |
| 24 | 6 | 1.9% |
| 23 | 6 | 1.9% |
| 22 | 6 | 1.9% |
| 21 | 6 | 1.9% |
| 20 | 6 | 1.9% |
| 19 | 6 | 1.9% |
| 18 | 6 | 1.9% |
| 17 | 6 | 1.9% |
| Other values (43) | 254 |
| Value | Count | Frequency (%) |
| 1 | 6 | |
| 2 | 6 | |
| 3 | 6 | |
| 4 | 6 | |
| 5 | 6 |
| Value | Count | Frequency (%) |
| 53 | 2 | 0.6% |
| 52 | 6 | |
| 51 | 6 | |
| 50 | 6 | |
| 49 | 6 |
SEASON
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 KiB |
| 1 | |
|---|---|
| 2 | |
| 3 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 314 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 4 |
| 4th row | 4 |
| 5th row | 4 |
| Value | Count | Frequency (%) |
| 1 | 84 | |
| 2 | 79 | |
| 3 | 78 | |
| 4 | 73 |
| Value | Count | Frequency (%) |
| 1 | 84 | |
| 2 | 79 | |
| 3 | 78 | |
| 4 | 73 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 84 | |
| 2 | 79 | |
| 3 | 78 | |
| 4 | 73 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 314 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 84 | |
| 2 | 79 | |
| 3 | 78 | |
| 4 | 73 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 314 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 84 | |
| 2 | 79 | |
| 3 | 78 | |
| 4 | 73 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 314 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 84 | |
| 2 | 79 | |
| 3 | 78 | |
| 4 | 73 |
| Distinct | 157 |
|---|---|
| Distinct (%) | 50.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.46563526 |
|---|---|
| Minimum | 0 |
| Maximum | 266.6325301 |
| Zeros | 158 |
| Zeros (%) | 50.3% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 79.67566708 |
| 95-th percentile | 152.2670683 |
| Maximum | 266.6325301 |
| Range | 266.6325301 |
| Interquartile range (IQR) | 79.67566708 |
Descriptive statistics
| Standard deviation | 53.73795679 |
|---|---|
| Coefficient of variation (CV) | 1.20852781 |
| Kurtosis | 0.4482246595 |
| Mean | 44.46563526 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.028076347 |
| Sum | 13962.20947 |
| Variance | 2887.768 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 158 | |
| 68.32335329 | 1 | 0.3% |
| 38.74404762 | 1 | 0.3% |
| 48.18787879 | 1 | 0.3% |
| 101.5301205 | 1 | 0.3% |
| 91.62424242 | 1 | 0.3% |
| 139.9052632 | 1 | 0.3% |
| 99.16071429 | 1 | 0.3% |
| 99.21212121 | 1 | 0.3% |
| 24.18787879 | 1 | 0.3% |
| Other values (147) | 147 |
| Value | Count | Frequency (%) |
| 0 | 158 | |
| 18.66071429 | 1 | 0.3% |
| 22.95238095 | 1 | 0.3% |
| 24.18787879 | 1 | 0.3% |
| 26.04819277 | 1 | 0.3% |
| Value | Count | Frequency (%) |
| 266.6325301 | 1 | |
| 214.4390244 | 1 | |
| 194.4099379 | 1 | |
| 176.2160494 | 1 | |
| 175.6845238 | 1 |
| Distinct | 150 |
|---|---|
| Distinct (%) | 47.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.22140165 |
|---|---|
| Minimum | 0 |
| Maximum | 248.3115942 |
| Zeros | 165 |
| Zeros (%) | 52.5% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 77.80208485 |
| 95-th percentile | 167.8439024 |
| Maximum | 248.3115942 |
| Range | 248.3115942 |
| Interquartile range (IQR) | 77.80208485 |
Descriptive statistics
| Standard deviation | 55.38134783 |
|---|---|
| Coefficient of variation (CV) | 1.281340857 |
| Kurtosis | 0.5870552698 |
| Mean | 43.22140165 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.146887486 |
| Sum | 13571.52012 |
| Variance | 3067.093688 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 165 | |
| 194.4011976 | 1 | 0.3% |
| 53.3902439 | 1 | 0.3% |
| 130.3669065 | 1 | 0.3% |
| 10.45454545 | 1 | 0.3% |
| 248.3115942 | 1 | 0.3% |
| 75.2 | 1 | 0.3% |
| 106.8 | 1 | 0.3% |
| 46.81927711 | 1 | 0.3% |
| 108.4578313 | 1 | 0.3% |
| Other values (140) | 140 |
| Value | Count | Frequency (%) |
| 0 | 165 | |
| 6 | 1 | 0.3% |
| 9.333333333 | 1 | 0.3% |
| 10.45454545 | 1 | 0.3% |
| 13.02 | 1 | 0.3% |
| Value | Count | Frequency (%) |
| 248.3115942 | 1 | |
| 208 | 1 | |
| 197.6506024 | 1 | |
| 196.595092 | 1 | |
| 195.0472973 | 1 |
| Distinct | 157 |
|---|---|
| Distinct (%) | 50.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.26967966 |
|---|---|
| Minimum | 0 |
| Maximum | 249.6319018 |
| Zeros | 158 |
| Zeros (%) | 50.3% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 76.76964286 |
| 95-th percentile | 159.803912 |
| Maximum | 249.6319018 |
| Range | 249.6319018 |
| Interquartile range (IQR) | 76.76964286 |
Descriptive statistics
| Standard deviation | 54.09444422 |
|---|---|
| Coefficient of variation (CV) | 1.221929877 |
| Kurtosis | 0.3846405306 |
| Mean | 44.26967966 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.058025743 |
| Sum | 13900.67941 |
| Variance | 2926.208896 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 158 | |
| 82.76470588 | 1 | 0.3% |
| 78.25149701 | 1 | 0.3% |
| 45.54268293 | 1 | 0.3% |
| 73.54216867 | 1 | 0.3% |
| 55.77710843 | 1 | 0.3% |
| 159.3915663 | 1 | 0.3% |
| 174.8073394 | 1 | 0.3% |
| 104.6607143 | 1 | 0.3% |
| 90.23780488 | 1 | 0.3% |
| Other values (147) | 147 |
| Value | Count | Frequency (%) |
| 0 | 158 | |
| 13.7797619 | 1 | 0.3% |
| 17.72289157 | 1 | 0.3% |
| 23.20714286 | 1 | 0.3% |
| 28.54658385 | 1 | 0.3% |
| Value | Count | Frequency (%) |
| 249.6319018 | 1 | |
| 208.1515152 | 1 | |
| 194.1677019 | 1 | |
| 186.8773006 | 1 | |
| 183.2108434 | 1 |
PM_CENTRO
Real number (ℝ≥0)
| Distinct | 311 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 96.21641491 |
|---|---|
| Minimum | 17.73214286 |
| Maximum | 271.8433735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 17.73214286 |
|---|---|
| 5-th percentile | 36.55089286 |
| Q1 | 66.08725163 |
| median | 86.35825119 |
| Q3 | 118.6997166 |
| 95-th percentile | 182.0143933 |
| Maximum | 271.8433735 |
| Range | 254.1112306 |
| Interquartile range (IQR) | 52.61246501 |
Descriptive statistics
| Standard deviation | 45.41258061 |
|---|---|
| Coefficient of variation (CV) | 0.4719837115 |
| Kurtosis | 1.644776369 |
| Mean | 96.21641491 |
| Median Absolute Deviation (MAD) | 25.02874242 |
| Skewness | 1.154750541 |
| Sum | 30211.95428 |
| Variance | 2062.302478 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 98.45833333 | 2 | 0.6% |
| 83.25595238 | 2 | 0.6% |
| 70.83333333 | 2 | 0.6% |
| 115.9027778 | 1 | 0.3% |
| 105.8614458 | 1 | 0.3% |
| 126.005988 | 1 | 0.3% |
| 80.01796407 | 1 | 0.3% |
| 61.81481481 | 1 | 0.3% |
| 70.26946108 | 1 | 0.3% |
| 68.20833333 | 1 | 0.3% |
| Other values (301) | 301 |
| Value | Count | Frequency (%) |
| 17.73214286 | 1 | |
| 21.51190476 | 1 | |
| 23.91666667 | 1 | |
| 25.78289474 | 1 | |
| 29.18562874 | 1 |
| Value | Count | Frequency (%) |
| 271.8433735 | 1 | |
| 266 | 1 | |
| 254.4047619 | 1 | |
| 242.9345238 | 1 | |
| 234.327381 | 1 |
| Distinct | 311 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.029029838 |
|---|---|
| Minimum | -21.68229167 |
| Maximum | 23.61904762 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | -21.68229167 |
|---|---|
| 5-th percentile | -18.67529762 |
| Q1 | -10.11309524 |
| median | 2.74702381 |
| Q3 | 14.74553571 |
| 95-th percentile | 21.37113095 |
| Maximum | 23.61904762 |
| Range | 45.30133929 |
| Interquartile range (IQR) | 24.85863095 |
Descriptive statistics
| Standard deviation | 13.383303 |
|---|---|
| Coefficient of variation (CV) | 6.595912364 |
| Kurtosis | -1.344081318 |
| Mean | 2.029029838 |
| Median Absolute Deviation (MAD) | 12.31845238 |
| Skewness | -0.04594958744 |
| Sum | 637.1153693 |
| Variance | 179.1127991 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| -18.08333333 | 2 | 0.6% |
| -1.375 | 2 | 0.6% |
| 17.4702381 | 2 | 0.6% |
| -1.982142857 | 1 | 0.3% |
| 7.303571429 | 1 | 0.3% |
| -19.54166667 | 1 | 0.3% |
| -6.523809524 | 1 | 0.3% |
| -19.45833333 | 1 | 0.3% |
| -9.202380952 | 1 | 0.3% |
| 19.94642857 | 1 | 0.3% |
| Other values (301) | 301 |
| Value | Count | Frequency (%) |
| -21.68229167 | 1 | |
| -21.18452381 | 1 | |
| -20.89880952 | 1 | |
| -20.82142857 | 1 | |
| -20.16071429 | 1 |
| Value | Count | Frequency (%) |
| 23.61904762 | 1 | |
| 23.47619048 | 1 | |
| 23.375 | 1 | |
| 23.24404762 | 1 | |
| 23.13095238 | 1 |
HUMIDITY
Real number (ℝ≥0)
| Distinct | 311 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.55365172 |
|---|---|
| Minimum | 0 |
| Maximum | 97.22916667 |
| Zeros | 1 |
| Zeros (%) | 0.3% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 29.27797619 |
| Q1 | 42.4047619 |
| median | 55.29464286 |
| Q3 | 65.90327381 |
| 95-th percentile | 79.2014881 |
| Maximum | 97.22916667 |
| Range | 97.22916667 |
| Interquartile range (IQR) | 23.4985119 |
Descriptive statistics
| Standard deviation | 15.91684377 |
|---|---|
| Coefficient of variation (CV) | 0.2917649556 |
| Kurtosis | -0.4834138936 |
| Mean | 54.55365172 |
| Median Absolute Deviation (MAD) | 12.14880952 |
| Skewness | -0.1677940946 |
| Sum | 17129.84664 |
| Variance | 253.3459157 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 55.4047619 | 2 | 0.6% |
| 50.98809524 | 2 | 0.6% |
| 65.88690476 | 2 | 0.6% |
| 68.16071429 | 1 | 0.3% |
| 30.765625 | 1 | 0.3% |
| 77.26785714 | 1 | 0.3% |
| 33.61309524 | 1 | 0.3% |
| 64.51785714 | 1 | 0.3% |
| 85.51190476 | 1 | 0.3% |
| 69.69642857 | 1 | 0.3% |
| Other values (301) | 301 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 18.3452381 | 1 | |
| 21.44047619 | 1 | |
| 21.50595238 | 1 | |
| 22.00595238 | 1 |
| Value | Count | Frequency (%) |
| 97.22916667 | 1 | |
| 85.51190476 | 1 | |
| 84.88095238 | 1 | |
| 83.43452381 | 1 | |
| 82.79761905 | 1 |
PREASSURE
Real number (ℝ≥0)
| Distinct | 306 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1013.289801 |
|---|---|
| Minimum | 0 |
| Maximum | 1036.470238 |
| Zeros | 1 |
| Zeros (%) | 0.3% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1001.956845 |
| Q1 | 1007.831845 |
| median | 1016.955357 |
| Q3 | 1023.982143 |
| 95-th percentile | 1030.81369 |
| Maximum | 1036.470238 |
| Range | 1036.470238 |
| Interquartile range (IQR) | 16.15029762 |
Descriptive statistics
| Standard deviation | 58.11599363 |
|---|---|
| Coefficient of variation (CV) | 0.05735377338 |
| Kurtosis | 297.9494666 |
| Mean | 1013.289801 |
| Median Absolute Deviation (MAD) | 7.916666667 |
| Skewness | -17.03856178 |
| Sum | 318172.9976 |
| Variance | 3377.468716 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1000.964286 | 2 | 0.6% |
| 1023.982143 | 2 | 0.6% |
| 1018.458333 | 2 | 0.6% |
| 1022.559524 | 2 | 0.6% |
| 1029.625 | 2 | 0.6% |
| 1004.875 | 2 | 0.6% |
| 1018.75 | 2 | 0.6% |
| 1011.857143 | 2 | 0.6% |
| 1002.202381 | 1 | 0.3% |
| 1003.797619 | 1 | 0.3% |
| Other values (296) | 296 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 997.2678571 | 1 | |
| 1000.416667 | 1 | |
| 1000.547619 | 1 | |
| 1000.684524 | 1 |
| Value | Count | Frequency (%) |
| 1036.470238 | 1 | |
| 1034.047619 | 1 | |
| 1033.635417 | 1 | |
| 1033.354167 | 1 | |
| 1032.946429 | 1 |
| Distinct | 314 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.84754088 |
|---|---|
| Minimum | -1.862217018 |
| Maximum | 31.47111632 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | -1.862217018 |
|---|---|
| 5-th percentile | 3.592414374 |
| Q1 | 8.428815379 |
| median | 19.38095238 |
| Q3 | 26.88729508 |
| 95-th percentile | 30.03449454 |
| Maximum | 31.47111632 |
| Range | 33.33333333 |
| Interquartile range (IQR) | 18.4584797 |
Descriptive statistics
| Standard deviation | 9.282351052 |
|---|---|
| Coefficient of variation (CV) | 0.5200913177 |
| Kurtosis | -1.389319215 |
| Mean | 17.84754088 |
| Median Absolute Deviation (MAD) | 8.62363388 |
| Skewness | -0.20254832 |
| Sum | 5604.127835 |
| Variance | 86.16204105 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 16.70725995 | 1 | 0.3% |
| 6.393052303 | 1 | 0.3% |
| 27.6459797 | 1 | 0.3% |
| 24.5185402 | 1 | 0.3% |
| 26.71409055 | 1 | 0.3% |
| 5.065964091 | 1 | 0.3% |
| 8.617876659 | 1 | 0.3% |
| 7.485948478 | 1 | 0.3% |
| 29.10967994 | 1 | 0.3% |
| 24.33313817 | 1 | 0.3% |
| Other values (304) | 304 |
| Value | Count | Frequency (%) |
| -1.862217018 | 1 | |
| 0.1576893052 | 1 | |
| 1.204234973 | 1 | |
| 1.995446266 | 1 | |
| 2.323965652 | 1 |
| Value | Count | Frequency (%) |
| 31.47111632 | 1 | |
| 31.11494926 | 1 | |
| 30.95882123 | 1 | |
| 30.93442623 | 1 | |
| 30.83380779 | 1 |
| Distinct | 314 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.34791701 |
|---|---|
| Minimum | 3.302202381 |
| Maximum | 177.1026667 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 3.302202381 |
|---|---|
| 5-th percentile | 5.621282738 |
| Q1 | 9.954895833 |
| median | 15.47050595 |
| Q3 | 27.25004464 |
| 95-th percentile | 65.0183404 |
| Maximum | 177.1026667 |
| Range | 173.8004643 |
| Interquartile range (IQR) | 17.29514881 |
Descriptive statistics
| Standard deviation | 23.12628606 |
|---|---|
| Coefficient of variation (CV) | 0.9905074637 |
| Kurtosis | 11.44095404 |
| Mean | 23.34791701 |
| Median Absolute Deviation (MAD) | 6.978541667 |
| Skewness | 2.936798241 |
| Sum | 7331.24594 |
| Variance | 534.8251067 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 13.26041667 | 1 | 0.3% |
| 12.31196429 | 1 | 0.3% |
| 22.3825 | 1 | 0.3% |
| 20.62815476 | 1 | 0.3% |
| 12.24190476 | 1 | 0.3% |
| 10.73619048 | 1 | 0.3% |
| 66.62660714 | 1 | 0.3% |
| 10.46202381 | 1 | 0.3% |
| 4.999940476 | 1 | 0.3% |
| 9.917559524 | 1 | 0.3% |
| Other values (304) | 304 |
| Value | Count | Frequency (%) |
| 3.302202381 | 1 | |
| 3.706826347 | 1 | |
| 4.200238095 | 1 | |
| 4.219583333 | 1 | |
| 4.265119048 | 1 |
| Value | Count | Frequency (%) |
| 177.1026667 | 1 | |
| 140.5269048 | 1 | |
| 138.5585714 | 1 | |
| 115.4180357 | 1 | |
| 110.7311905 | 1 |
| Distinct | 127 |
|---|---|
| Distinct (%) | 40.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3192.679299 |
|---|---|
| Minimum | 0 |
| Maximum | 999990 |
| Zeros | 130 |
| Zeros (%) | 41.4% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.8 |
| Q3 | 10.05 |
| 95-th percentile | 39.05 |
| Maximum | 999990 |
| Range | 999990 |
| Interquartile range (IQR) | 10.05 |
Descriptive statistics
| Standard deviation | 56432.25065 |
|---|---|
| Coefficient of variation (CV) | 17.67551494 |
| Kurtosis | 313.9999333 |
| Mean | 3192.679299 |
| Median Absolute Deviation (MAD) | 0.8 |
| Skewness | 17.72004233 |
| Sum | 1002501.3 |
| Variance | 3184598913 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 130 | |
| 0.1 | 10 | 3.2% |
| 0.7 | 5 | 1.6% |
| 0.2 | 5 | 1.6% |
| 4.9 | 4 | 1.3% |
| 3.1 | 4 | 1.3% |
| 0.8 | 4 | 1.3% |
| 3.4 | 4 | 1.3% |
| 10.1 | 3 | 1.0% |
| 1.1 | 3 | 1.0% |
| Other values (117) | 142 |
| Value | Count | Frequency (%) |
| 0 | 130 | |
| 0.1 | 10 | 3.2% |
| 0.2 | 5 | 1.6% |
| 0.3 | 1 | 0.3% |
| 0.4 | 2 | 0.6% |
| Value | Count | Frequency (%) |
| 999990 | 1 | |
| 223 | 1 | |
| 102.3 | 1 | |
| 75.8 | 1 | |
| 74.1 | 1 |
| Distinct | 314 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2012766.688 |
|---|---|
| Minimum | 2010010 |
| Maximum | 2015530 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.9 KiB |
Quantile statistics
| Minimum | 2010010 |
|---|---|
| 5-th percentile | 2010166.5 |
| Q1 | 2011262.5 |
| median | 2012765 |
| Q3 | 2014267.5 |
| 95-th percentile | 2015373.5 |
| Maximum | 2015530 |
| Range | 5520 |
| Interquartile range (IQR) | 3005 |
Descriptive statistics
| Standard deviation | 1723.421958 |
|---|---|
| Coefficient of variation (CV) | 0.0008562452708 |
| Kurtosis | -1.256219614 |
| Mean | 2012766.688 |
| Median Absolute Deviation (MAD) | 1505 |
| Skewness | 0.003308513388 |
| Sum | 632008740 |
| Variance | 2970183.244 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) |
| 2010110 | 1 | 0.3% |
| 2015250 | 1 | 0.3% |
| 2011290 | 1 | 0.3% |
| 2013340 | 1 | 0.3% |
| 2010270 | 1 | 0.3% |
| 2015060 | 1 | 0.3% |
| 2012320 | 1 | 0.3% |
| 2014370 | 1 | 0.3% |
| 2011300 | 1 | 0.3% |
| 2013350 | 1 | 0.3% |
| Other values (304) | 304 |
| Value | Count | Frequency (%) |
| 2010010 | 1 | |
| 2010020 | 1 | |
| 2010030 | 1 | |
| 2010040 | 1 | |
| 2010050 | 1 |
| Value | Count | Frequency (%) |
| 2015530 | 1 | |
| 2015520 | 1 | |
| 2015510 | 1 | |
| 2015500 | 1 | |
| 2015490 | 1 |
YearWeek
Date
| Distinct | 313 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 KiB |
| Minimum | 2010-01-10 00:00:00 |
|---|---|
| Maximum | 2016-01-10 00:00:00 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| YEAR | Week | SEASON | PM_RETIRO | PM_VALLECAS | PM_CIUDADLINEAL | PM_CENTRO | DEW_POINT | HUMIDITY | PREASSURE | TEMPERATURE | WIND_SPEED | COMMULATIVE_PRECIPITATION | formatted_date | YearWeek | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2010 | 1 | 4 | 0.0 | 0.0 | 0.0 | 74.119048 | -19.976190 | 50.678571 | 1031.470238 | -1.862217 | 32.778571 | 0.0 | 2010010 | 2010-01-10 |
| 1 | 2010 | 2 | 4 | 0.0 | 0.0 | 0.0 | 88.250000 | -18.083333 | 49.750000 | 1031.345238 | 0.157689 | 43.464464 | 0.0 | 2010020 | 2010-01-17 |
| 2 | 2010 | 3 | 4 | 0.0 | 0.0 | 0.0 | 131.897059 | -14.202381 | 46.404762 | 1028.255952 | 5.017174 | 38.843810 | 0.0 | 2010030 | 2010-01-24 |
| 3 | 2010 | 4 | 4 | 0.0 | 0.0 | 0.0 | 63.413534 | -17.744048 | 29.684524 | 1023.738095 | 7.002927 | 51.740417 | 0.0 | 2010040 | 2010-01-31 |
| 4 | 2010 | 5 | 4 | 0.0 | 0.0 | 0.0 | 76.416667 | -14.017857 | 52.934524 | 1027.625000 | 3.836456 | 10.406071 | 0.0 | 2010050 | 2010-02-07 |
| 5 | 2010 | 6 | 4 | 0.0 | 0.0 | 0.0 | 80.017964 | -16.982143 | 38.130952 | 1029.416667 | 5.144028 | 14.127321 | 0.0 | 2010060 | 2010-02-14 |
| 6 | 2010 | 7 | 4 | 0.0 | 0.0 | 0.0 | 98.898810 | -16.130952 | 36.339286 | 1022.559524 | 6.393052 | 11.960714 | 0.0 | 2010070 | 2010-02-21 |
| 7 | 2010 | 8 | 4 | 0.0 | 0.0 | 0.0 | 133.523810 | -5.494048 | 63.172619 | 1015.505952 | 8.617877 | 17.373036 | 4.7 | 2010080 | 2010-02-28 |
| 8 | 2010 | 9 | 1 | 0.0 | 0.0 | 0.0 | 94.410714 | -10.154762 | 52.607143 | 1025.464286 | 7.485948 | 24.873631 | 5.1 | 2010090 | 2010-03-07 |
| 9 | 2010 | 10 | 1 | 0.0 | 0.0 | 0.0 | 70.553571 | -10.559524 | 49.101190 | 1024.339286 | 8.149493 | 26.571786 | 10.1 | 2010100 | 2010-03-14 |
Last rows
| YEAR | Week | SEASON | PM_RETIRO | PM_VALLECAS | PM_CIUDADLINEAL | PM_CENTRO | DEW_POINT | HUMIDITY | PREASSURE | TEMPERATURE | WIND_SPEED | COMMULATIVE_PRECIPITATION | formatted_date | YearWeek | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 304 | 2015 | 44 | 3 | 29.637500 | 74.500000 | 28.546584 | 29.839286 | -3.041667 | 50.154762 | 1024.220238 | 14.609290 | 29.899583 | 4.3 | 2015440 | 2015-11-08 |
| 305 | 2015 | 45 | 3 | 94.523810 | 52.193548 | 96.255952 | 93.351190 | 1.904762 | 75.504132 | 1025.198347 | 12.833333 | 17.471548 | 999990.0 | 2015450 | 2015-11-15 |
| 306 | 2015 | 46 | 3 | 175.684524 | 208.000000 | 183.210843 | 175.952381 | 4.898204 | 0.000000 | 0.000000 | 13.070973 | 3.706826 | 0.0 | 2015460 | 2015-11-22 |
| 307 | 2015 | 47 | 3 | 57.363636 | 70.647059 | 59.298137 | 60.482143 | 0.571429 | 97.229167 | 1033.354167 | 9.862022 | 16.389226 | 7.1 | 2015470 | 2015-11-29 |
| 308 | 2015 | 48 | 3 | 140.564417 | 6.000000 | 148.794521 | 135.416667 | -9.202381 | 70.250000 | 1031.916667 | 3.987705 | 20.563631 | 0.0 | 2015480 | 2015-12-06 |
| 309 | 2015 | 49 | 3 | 176.216049 | 174.142857 | 168.098765 | 160.455090 | -7.706587 | 59.700599 | 1024.952096 | 7.981152 | 57.305150 | 0.0 | 2015490 | 2015-12-13 |
| 310 | 2015 | 50 | 4 | 170.718563 | 193.800000 | 179.491018 | 169.714286 | -3.577381 | 74.410714 | 1027.988095 | 8.403201 | 5.003631 | 0.0 | 2015500 | 2015-12-20 |
| 311 | 2015 | 51 | 4 | 90.795181 | 13.020000 | 97.029940 | 97.454545 | -9.684524 | 55.404762 | 1029.779762 | 7.080991 | 77.864940 | 0.7 | 2015510 | 2015-12-27 |
| 312 | 2015 | 52 | 4 | 266.632530 | 248.311594 | 249.631902 | 254.404762 | -6.523810 | 76.750000 | 1027.345238 | 5.539227 | 4.200238 | 0.0 | 2015520 | 2016-01-03 |
| 313 | 2015 | 53 | 4 | 139.905263 | 181.055556 | 150.473684 | 154.229167 | -9.229167 | 63.687500 | 1031.687500 | 5.473361 | 12.619271 | 0.0 | 2015530 | 2016-01-10 |